Cost Allocation Operational report
Use this report to validate that allocations were processed correctly. This report includes multiple report sheets, each of which has a specific purpose.
NOTE: Although this report refreshes automatically when you open it, you must refresh it manually to populate the MGTGL_DEPT_Detail sheet.
View the Cost Allocation Operational report:
-
From the Command Center, click Organizational Profitability.
-
Click View Reports.
-
Click Cost Allocation Operational Report. The report opens in the Desktop client.
-
From the Refresh Variables panel, select the following from the drop-down lists, and then click Apply.
NOTE: When using the Microsoft Excel version of the report, on the Main ribbon tab, click Refresh to open the Refresh Variables dialog. Select the options using the following table, and then click OK.
Refresh Variable Description Sync report to system year and period? Do one of the following:
-
To refresh the report to include the current system year and period values, select Yes.
-
To include values from a fiscal year and period, select No. The system prompts you to enter a fiscal year and select a fiscal period.
-
MGTGL_AllocID_Summary sheet
This sheet sums allocation charges and offsets posted to the target MGTGLYYYY, by allocation ID, to verify the following:
- Allocation offsets total to allocation charges.
-
Allocation charges in the MGTGLYYYY table equal allocation charges posted to the AllocationDetail table.
Click image to view full size
AllocDetail_AllocID_Summary sheet
This sheet sums allocation charges posted to the AllocationDetail table, by allocation ID, to verify that allocation charges equal those posted to the MGTGLYYYY table.
Click image to view full size
MGTGL_DEPT_Detail sheet
This sheet queries allocation charges and offsets by department and by allocated direct expenses and reallocated expenses.
The report worksheet ensures the following across the organization:
- Allocated direct expenses and income plus allocated direct expense and income offsets net to zero
- Reallocated expenses and income plus reallocated expense and income offsets net to zero
- Net allocated expenses and income equals zero
Click image to view full size
NOTE: You can also create a new Cost Allocation Operational report using the template in the Report Center. See Creating new web reports from template for more information.
